----------------------------------
-- wechat_menu
---------------------------------
insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '4G专区', 'complex', null, null, 0, 1, 0, 'woshimorendeappid123');
insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '4G免费换卡', 'view', null, 'http://103.227.80.253/FourG/FourGWeb/FourGHuanKa.htm', 1, 11, 0, 'woshimorendeappid123');
insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '4G套餐办理', 'click', '41', null, 1, 12, 0, 'woshimorendeappid123');
insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '4G流量包办理', 'view', null, 'http://103.227.80.253/FourG/FourGWeb/FourGFlowPackage.html', 1, 13, 0, 'woshimorendeappid123');
insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '4G特色业务', 'click', '43', null, 1, 14, 0, 'woshimorendeappid123');
insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '4G资费规则', 'click', '44', null, 1, 15, 0, 'woshimorendeappid123');

insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '自助服务', 'complex', null, null, 0, 2, 0, 'woshimorendeappid123');	
insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '充值99折', 'view', null, 'http://wap.10086.cn/czjf/czjf.jsp', 7, 21, 0, 'woshimorendeappid123');
insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '我的余额', 'view', null, 'http://wap.10086.cn/ywcx/yecx.jsp', 7, 22, 0, 'woshimorendeappid123');
insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '我的流量', 'view', null, 'http://wap.10086.cn/ywcx/llcx.jsp', 7, 23, 0, 'woshimorendeappid123');	
insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '我的账单', 'view', null, 'http://wap.10086.cn/ywcx/zdcx.jsp', 7, 24, 0, 'woshimorendeappid123');
insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '加油包办理', 'click', '26', null, 7, 25, 0, 'woshimorendeappid123');

insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '我要精彩', 'complex', null, null, 0, 3, 0, 'woshimorendeappid123');
insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '❤微吧❤', 'view', null, 'http://wx.wsq.qq.com/251918512', 13, 31, 0, 'woshimorendeappid123');
insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '★手机商城★', 'view', null, 'http://123.103.63.75:8087/MobileDisplay/AllMobile.aspx', 13, 32, 0, 'woshimorendeappid123');
insert into WECHAT_MENU (id, name, type, key, url, parentid, sort, status, appid)
	values (seq_wechat_menu.nextval, '⊙附近营业厅⊙', 'location_select', 'rselfmenu', null, 13, 33, 0, 'woshimorendeappid123');


----------------------------------
-- wechat_article
---------------------------------
insert into WECHAT_ARTICLE (id, parentid, title, description, picurl, url, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, sort)
    values (seq_wechat_article.nextval, 0, '【天猫充值99折】精打细算的看过来！', '在天猫商城中国移动官方旗舰店的内蒙古专区充值，即可享受30元、50元、100元、200元、300元、500元话费充值99折优惠。速来充值吧，亲！', 'wechatArticles/26459250-ab30-4b02-9a09-582396c2f4bf.png', 'http://mp.weixin.qq.com/s?__biz=MzA4NzQ1NjUxMg=='||'&'||'mid=200224867'||'&'||'idx=3'||'&'||'sn=62cfc0bfa013da4d2489fa0ea4cd96ac#rd', 0, to_timestamp('18-09-2014 15:59:16.385000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 11:16:20.620000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', 1);


----------------------------------
-- wechat_resp
---------------------------------
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
  values (seq_wechat_resp.nextval, 'text', '内蒙古移动欢迎您~', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:34:30.396000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:24:36.606000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', 'welcome', 0, 'welcome', 0, '内蒙古移动欢迎您~', 1);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
  values (seq_wechat_resp.nextval, 'text', '内蒙古移动欢迎您~~', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:34:30.396000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:24:36.606000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', 'default', 0, 'default', 0, '内蒙古移动欢迎您~~', 1);

-- 1
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
  values (seq_wechat_resp.nextval, 'text', '业务查询', null, null, null, null, null, null, 0, to_timestamp('14-10-2014 14:42:39.298000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 17:11:08.974000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '1', 0, '1', 0, '业务查询', 1);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
  values (seq_wechat_resp.nextval, 'text', '尊贵的用户<a href="http://wap.10086.cn/ywcx/llcx.jsp">【点击此处】</a>可查询您当月已使用数据流量信息', null, null, null, null, null, null, 0, to_timestamp('15-09-2014 16:08:23.822000', 'dd-mm-yyyy hh24:mi:ss.ff'), 2, to_timestamp('22-10-2014 17:12:31.401000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '流量', 0, '11', 0, '流量查询', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
  values (seq_wechat_resp.nextval, 'text', '尊贵的用户<a href="http://wap.10086.cn/ywcx/jfcx.jsp">【点击此处】</a>可查询您所属品牌本年度消费及奖励积分信息', null, null, null, null, null, null, 0, to_timestamp('15-09-2014 16:11:24.707000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 17:12:50.293000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '积分', 0, '12', 0, '积分查询', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '尊贵的用户<a href="http://wap.10086.cn/ywcx/yecx.jsp">【点击此处】</a>可查询您当前账户余额信息', null, null, null, null, null, null, 0, to_timestamp('15-09-2014 16:11:56.157000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:27:21.585000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '余额 话费', 0, '13', 0, '余额查询', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '尊贵的用户<a href="http://wap.10086.cn/ywcx/zdcx.jsp">【点击此处】</a>可查询您当月与最近5个月的账单信息', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 10:35:21.450000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('23-09-2014 14:45:40.055000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '账单', 0, '14', 0, '帐单查询', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '尊贵的用户<a href="http://wap.10086.cn/ywcx/zyywcx.jsp">【点击此处】</a>可查询您所开通的在用业务', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:29:25.609000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:25:47.457000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '在用 业务 查询', 0, '15', 0, '在用业务查询', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '请点击【+】按钮，【发送位置】信息查询附近营业厅。', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:22:04.836000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:42:12.611000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '附近 营业厅', 0, '16', 0, '附近营业厅', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '尊贵的用户<a href="http://mp.weixin.qq.com/mp/getmasssendmsg?__biz=MzA4NzQ1NjUxMg==#wechat_webview_type=1'||'&'||'wechat_redirect">【点击此处】</a>可查询图文消息历史', null, null, null, null, null, null, 0, to_timestamp('14-10-2014 15:19:16.859000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('14-10-2014 15:19:16.859000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '往期 回顾', 0, '17', 0, '往期回顾', 0);

-- 2
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
  values (seq_wechat_resp.nextval, 'text', '业务办理', null, null, null, null, null, null, 0, to_timestamp('14-10-2014 14:44:03.285000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 17:03:47.866000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '2', 0, '2', 0, '业务办理', 1);

insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '套餐办理', null, null, null, null, null, null, 0, to_timestamp('14-10-2014 15:31:35.504000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 16:19:57.989000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '21', 0, '21', 0, '套餐办理', 1);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击办理<a href="http://wap.10086.cn/banli-tc-gotone.html">【全球通统一资费】</a>您可根据自己的需求选择适合的套餐，并可以优惠的价格享受短信包、彩信包、音乐包等专属数据业务优惠。', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:07:05.347000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('23-09-2014 15:35:02.838000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '全球通', 0, '211', 0, '全球通统一资费套餐', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击办理 <a href="http://wap.10086.cn/banli-tc-wlan.html">【随e行无线宽带（WLAN）】</a>您可通过笔记本电脑、手机等终端在中国移动WLAN网络覆盖区域内接入互联网和企业网，获取信息、娱乐或进行办公。', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:10:42.534000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:26:59.315000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '随e行 无线 宽带 WLAN', 0, '212', 0, '随e行无线宽带（WLAN)', 0);

insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '生活·娱乐', null, null, null, null, null, null, 0, to_timestamp('14-10-2014 15:33:44.375000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 16:20:22.248000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '22', 0, '22', 0, '生活·娱乐', 1);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击办理<a href="http://wap.10086.cn/banli-yule-139mail.html">【139邮箱】</a>手机号就是邮箱帐号', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:11:35.569000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('23-09-2014 15:34:39.077000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '139邮箱', 0, '221', 0, '139邮箱', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击办理<a href="http://wap.10086.cn/banli-yule-fetion.html">【飞信】</a>永不离线，语音群聊，超低资费', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:12:19.244000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:41:50.717000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '飞信', 0, '222', 0, '飞信', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击办理<a href="http://wap.cytxl.com.cn/x.action">【和通讯录】</a>实现电话本信息备份功能', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:13:02.502000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('23-09-2014 15:34:50.014000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '和通讯录', 0, '223', 0, '和通讯录', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击办理<a href="http://wap.12530.com">【彩铃】</a>用悦耳的音乐替代普通回铃音', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:13:32.665000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('23-09-2014 15:34:54.948000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '彩铃', 0, '224', 0, '彩铃', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击办理<a href="http://a.10086.cn/pams2/m/s.do?p=72'||'&'||'j=l'||'&'||'c=172'||'&'||'gId=300000004151'||'&'||'blockId=17363'||'&'||'cuid=37048378">【手机导航】</a>一键人工导航', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:29:50.824000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:25:41.402000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '手机 导航', 0, '225', 0, '手机导航', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://m.weibo.10086.cn">【移动微博】</a>真实、好玩、实用', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:30:26.108000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:25:35.914000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '移动 微博', 0, '226', 0, '移动微博', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-yule-sjyl.html">【手机医疗】</a>掌上医疗便民服务', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:31:21.303000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:25:30.644000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '手机 医疗', 0, '227', 0, '手机医疗', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-yule-ydyysc.html">【移动应用商场】</a>精彩应用、成就梦想', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:32:08.889000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:25:25.224000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '移动 应用 商场', 0, '228', 0, '移动应用商场', 0);

insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '咨询·商务', null, null, null, null, null, null, 0, to_timestamp('14-10-2014 15:35:34.870000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 16:21:00.976000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '23', 0, '23', 0, '咨询·商务', 1);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击办理<a href="http://wap.10086.cn/banli-shangwu-sjb.html">【手机报】</a>提供及时便捷权威的资讯服务', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:14:08.963000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('23-09-2014 15:34:19.014000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '手机报', 0, '231', 0, '手机报', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-shangwu-12580.html">【12580业务】</a>一按我帮您', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:14:41.686000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('23-09-2014 15:34:13.464000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '12580', 0, '232', 0, '12580业务', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-shangwu-sjzq.html">【手机证券】</a>随身、随时、随地获取实时行情', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:18:30.466000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:27:35.097000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '手机 证券', 0, '233', 0, '手机证券', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-shangwu-ldtx.html">【来电提醒】</a>从来不会错过来电信息', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:32:36.302000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:25:15.972000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '来电 提醒', 0, '234', 0, '来电提醒', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-shangwu-kx.html">【快讯】</a>更低资费，超多资讯', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:33:03.755000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('23-09-2014 15:31:17.506000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '快讯', 0, '235', 0, '快讯', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击办理<a href="http://cmpay.10086.cn">【手机支付】</a>支持多种电子商务平台商品购买', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:33:40.838000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:25:07.696000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '手机 支付', 0, '236', 0, '手机支付', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-shangwu-sphy.html">【视频会议】</a>即时召开会议', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:34:08.046000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:25:02.133000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '视频 会议', 0, '237', 0, '视频会议', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-shangwu-sply.html">【视频留言】</a>可视化的留言', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:34:30.396000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:24:36.606000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '视频 留言', 0, '238', 0, '视频留言', 0);

insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '基础服务', null, null, null, null, null, null, 0, to_timestamp('14-10-2014 15:38:21.183000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 16:21:37.368000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '24', 0, '24', 0, '基础服务', 1);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击办理<a href="http://wap.10086.cn/banli-jichu-dxhz.html">【短信回执】</a>时时掌握短信是否发送成功', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:19:03.169000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:27:40.402000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '短信 回执', 0, '241', 0, '短信回执', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-jichu-hjdd.html">【呼叫等待】</a>可以拨打或接听第三方电话', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:19:29.625000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:27:49.823000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '呼叫 等待', 0, '242', 0, '呼叫等待', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-jichu-hjzy.html">【呼叫转移】</a>将来电转移到预先设定的号码上', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:19:59.041000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:27:56.834000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '呼叫 转移', 0, '243', 0, '呼叫转移', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-jichu-ldxs.html">【来电显示】</a>自动显示来电号码', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:20:25.293000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:28:03.427000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '来电 显示', 0, '244', 0, '来电显示', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-jichu-tkj.html">【停开机】</a>停复手机任意行', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:34:55.423000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:24:56.021000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '停开机 停机 开机', 0, '245', 0, '停开机', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-jichu-gprs.html">【GPRS功能】</a>数据流量轻松上网', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:35:20.535000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:24:30.426000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', 'GPRS 功能', 0, '246', 0, 'GPRS功能', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-jichu-dfth.html">【多方通话】</a>电话会议必备', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:35:49.263000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:24:22.304000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '多方 通话', 0, '247', 0, '多方通话', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-jichu-guoji-ct.html">【国际/港澳台长途】</a>', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:36:34.585000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:24:14.969000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '国际 港澳台 长途', 0, '248', 0, '国际/港澳台长途', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://wap.10086.cn/banli-jichu-guoji-my.html">【国际/港澳台漫游】</a>', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:36:57.887000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:24:07.305000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '国际 港澳台 漫游', 0, '249', 0, '国际/港澳台漫游', 0);

insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击<a href="http://wap.10086.cn/czjf/czjf.jsp">【手机充值】</a>立刻为本机或其他手机号码充值', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:28:42.462000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:25:53.933000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '手机 充值', 0, '25', 0, '手机充值', 0);

insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '加油包办理', null, null, null, null, null, null, 0, to_timestamp('22-09-2014 11:36:28.933000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:23:17.536000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '26', 0, '26', 0, '加油包办理', 1);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '【4G自动加油包】 \n月费：10元/月； \n提供自动加油包服务，客户选择后，每月套外按照10元/100M计费； \n发送短信代码【KTZDJYB10】至10086即可办理。', null, null, null, null, null, null, 0, to_timestamp('22-09-2014 11:24:27.454000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:23:28.841000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '4G 自动 加油包', 0, '261', 0, '4G自动加油包', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '【流量加油包】 \n月费：10元/月； \n客户主动选择订购，加油包内流量用完后需要再次发起订购； \n发送短信代码【KT4GJYB10】至10086即可办理。', null, null, null, null, null, null, 0, to_timestamp('22-09-2014 11:25:25.339000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:23:23.398000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '流量 加油包', 0, '262', 0, '流量加油包', 0);

-- 3
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '服务渠道指南', null, null, null, null, null, null, 0, to_timestamp('14-10-2014 14:45:06.179000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 17:05:03.709000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '3', 0, '3', 0, '服务渠道指南', 1);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '短信营业厅是中国移动通过短信向客户提供服务功能的渠道，移动客户可以通过发送短信来快速便捷的查询话费、了解最新优惠资讯、办理业务和套餐等等。随时随地，只要拿起您的手机，发个短信，还等什么呢？\n  操作方法 \n 1、编辑短信"10086"发送至"10086"，获取短信营业厅菜单，然后回复您所要办理业务的指定代码，轻松办理。\n 2、发送指定代码（如"开通彩铃"或"KTCL"）到10086，办理相应业务。\n 温馨提示\n 您发送或接收到10086的短信均是免费的。\n 业务不断更新，如有变化以实际办理方式为准', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:23:08.866000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:28:21.329000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '短信 营业厅', 0, '32', 0, '短信营业厅', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '网上营业厅是虚拟的营业厅，通过中国移动通信的互联网站，向各地客户提供以互联网为平台的业务咨询和办理，客户可以足不出户就获得和实体营业厅一样的服务与支持，让客户充分享受自由自在的感受。<a href="www.10086.cn">【www.10086.cn】</a>', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 11:59:49.096000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:28:27.369000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '网上 营业厅', 0, '33', 0, '网上营业厅', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '手机营业厅\n 中国移动手机营业厅是依托智能终端，面向全网客户提供快速便捷的查询、办理和交费等自助服务的客户端软件，支持优惠资讯等特色服务。覆盖Android、iOS等操作系统，与网上营业厅、掌上营业厅共同组成为中国移动的互联网渠道。客户可通过中国移动门户网站、MM应用商店、苹果商店等官方渠道下载安装。\n 下载地址： <a href="http://wap.10086.cn/sjyyt.html">【点击此处】</a>', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 12:00:15.888000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:28:32.678000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '手机 营业厅', 0, '34', 0, '手机营业厅', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', 'WAP营业厅是为方便您办理移动业务推出的一个便携随身的、集移动业务和优惠资讯为一体的电子化自助服务渠道。移动用户只要通过手机上网进入WAP营业厅，即可24小时随时随地查话费、办业务、找优惠，很潮很方便！\n 服务优势：\n 7×24小时随时随地不间断服务！不用电脑上网或去营业厅，手机上网轻松搞定！ 使用方法：<a href="http://wap.10086.cn">【点击进入】</a> \n1、手机终端输入wap.10086.cn即可登录中国移动WAP营业厅。\n 请使用cmwap方式访问。', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 12:03:16.623000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:28:40.434000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '掌上 营业厅', 0, '35', 0, '掌上营业厅', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '自助终端是移动公司为您打造的类似银行ATM机的24小时营业自助服务终端设备移动客户仅需按照屏幕提示进行操作，就可以享受自助交话费、查话费、打印账单和发票等服务。 \n服务优势 \n自助终端让您再也不用为长时间的排队等候而烦恼，操作方便、使用简单。 \n使用方法 \n指尖轻触自助终端屏幕上的按钮，按页面提示输入手机号码及客户服务密码，就可以轻松查询话费，自助办理多种业务。 \n温馨提示 \n通过自助终端进行话费缴纳、业务办理操作时，请根据界面提示进行操作，操作完毕后请点击右下角“退出”按钮，保证您的输入的号码安全退出终端。 \n业务不断更新，如有变化以实际网上营业厅为准。', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 12:04:32.773000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:28:45.869000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '自助 终端', 0, '36', 0, '自助终端', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '10086客户服务热线通过人工、自动语音、短信、传真、E-mail等方式为您24小时不间断提供有关移动通信的业务咨询、业务受理和投诉建议等专业服务。 \n　　无论您对移动业务是否熟悉，在这里，对于您的问题，我们都将专注聆听，向您提供全方位的信息。您不但可以增进对各项移动业务的了解，还可以享受常用信息带来的便利；您不但可以通晓现行资费及优惠情况，还可以及时掌握业务动态与最新消息。 \n　　无论是话费情况、手机故障或是网络问题，一切疑问都将迎刃而解，我们力求以真诚、高效的服务让您的移动之旅真正轻松无顾虑！ \n提醒 \n　　中国移动手机客户在国内主叫10086免收移动通话费（通话产生的长途费按实收取），接听10086来电免费。', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 12:05:32.851000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:28:56.273000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '10086 热线', 0, '37', 0, '10086热线', 0);

-- 4
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '4G业务办理', null, null, null, null, null, null, 0, to_timestamp('14-10-2014 14:45:49.342000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 17:05:51.738000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '4', 0, '4', 0, '4G业务办理', 1);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://103.227.80.253/FourG/FourGWeb/ZXTC.html">4G自选套餐</a> \n点击查看<a href="http://103.227.80.253/FourG/FourGWeb/FXTC.html">4G飞享套餐</a> \n点击查看<a href="http://103.227.80.253/FourG/FourGWeb/GradePlan.html">4G升舱计划</a>', null, null, null, null, null, null, 0, to_timestamp('22-09-2014 10:43:17.111000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:23:47.073000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '4G 套餐 办理', 0, '41', 0, '4G套餐办理', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击了解<a href="http://123.103.63.75:8087/FourG/FourGFlowPackage.html">【4G上网流量包】</a>', null, null, null, null, null, null, 0, to_timestamp('22-10-2014 18:16:40.323000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 18:38:49.364000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '42', 0, '42', 0, '4G上网流量包', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://103.227.80.253/FourG/FourGWeb/FourGMusicIntro.html">咪咕音乐</a> ' || chr(13) || '' || chr(10) || '        点击查看<a href="http://103.227.80.253/FourG/FourGWeb/AndGames.html">和游戏</a> ' || chr(13) || '' || chr(10) || '        点击查看<a href="http://103.227.80.253/FourG/FourGWeb/AndVedio.html">和视界</a> ' || chr(13) || '' || chr(10) || '        点击查看<a href="http://103.227.80.253/FourG/FourGWeb/AndRead.html">和阅读</a>', null, null, null, null, null, null, 0, to_timestamp('22-09-2014 10:52:13.061000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 08:49:35.608000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '4G 特色 业务', 0, '43', 0, '4G特色业务', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击查看<a href="http://103.227.80.253/FourG/FourGWeb/FourGKTGZ.html">开通规则</a> ' || chr(13) || '' || chr(10) || '        点击查看<a href="http://103.227.80.253/FourG/FourGWeb/FourGSXGZ.html">生效规则</a> ' || chr(13) || '' || chr(10) || '        点击查看<a href="http://103.227.80.253/FourG/FourGWeb/FourGZFYXQ.html">资费有效期</a> ' || chr(13) || '' || chr(10) || '        点击查看<a href="http://103.227.80.253/FourG/FourGWeb/FourGDZDGX.html">多终端共享</a> ' || chr(13) || '' || chr(10) || '        点击查看<a href="http://103.227.80.253/FourG/FourGWeb/FourGKHBHGZ.html">客户保护规则</a>', null, null, null, null, null, null, 0, to_timestamp('22-09-2014 10:58:25.244000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 08:47:35.640000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '4G 资费 规则', 0, '44', 0, '4G资费规则介绍', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击了解<a href="http://123.103.63.75:8087/FourG/FourGIndex.html">【办理流程】</a>', null, null, null, null, null, null, 0, to_timestamp('22-10-2014 18:39:21.548000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 18:39:54.632000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '45', 0, '45', 0, '办理流程', 0);

-- 5
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '移动品牌资费介绍', null, null, null, null, null, null, 0, to_timestamp('14-10-2014 14:46:25.732000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 17:53:56.024000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '5', 0, '5', 0, '移动品牌资费介绍', 1);

insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '全球通资费', null, null, null, null, null, null, 0, to_timestamp('14-10-2014 15:43:05.426000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 16:22:54.915000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '51', 0, '51', 0, '全球通资费', 1);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '【商旅套餐58元】  \n通话分钟数：150分钟国内主叫，被叫免费范围：国内，数据流量：30M，数据业务：来电显示 \n【商旅套餐88元】  \n通话分钟数： 350分钟国内主叫，被叫免费范围：国内，数据流量：30M，数据业务：来电显示 \n【商旅套餐128元】  \n通话分钟数：650分钟国内主叫，被叫免费范围：国内，数据流量：30M，数据业务：来电显示 \n【商旅套餐158元】  \n通话分钟数： 900分钟国内主叫，被叫免费范围：国内，数据流量：30M，数据业务：来电显示 \n【商旅套餐188元】  \n通话分钟数： 1200分钟国内主叫，被叫免费范围：国内，数据流量：30M，数据业务：来电显示 \n【商旅套餐288元】  \n通话分钟数： 1900分钟国内主叫，被叫免费范围：国内，数据流量：30M，数据业务：来电显示 \n【商旅套餐388元】  \n通话分钟数： 2600分钟国内主叫，被叫免费范围：国内，数据流量：30M，数据业务：来电显示 \n【商旅套餐588元】  \n通话分钟数： 4000分钟国内主叫，被叫免费范围：国内，数据流量：30M，数据业务：来电显示 \n【商旅套餐888元】  \n通话分钟数： 6000分钟国内主叫，被叫免费范围：国内，数据流量：30M，数据业务：来电显示', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 12:07:05.127000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:29:02.012000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '商旅 套餐', 0, '511', 0, '商旅套餐', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '【上网套餐58元】 \n通话分钟数：50分钟国内主叫，被叫免费范围：全国，数据流量：200M，数据业务：来电显示 \n【上网套餐88元】  \n通话分钟数：200分钟国内主，被叫免费范围：全国，数据流量：300M，数据业务：来电显示 \n【上网套餐128元】  \n通话分钟数：420分钟国内主，被叫免费范围：全国，数据流量：400M，数据业务：来电显示 \n【上网套餐158元】  \n通话分钟数：510分钟国内主叫，被叫免费范围：全国，数据流量：450M，数据业务：来电显示 \n【上网套餐188元】  \n通话分钟数：600分钟国内主叫，被叫免费范围：全国，数据流量：500M，数据业务：来电显示 \n【上网套餐288元】  \n通话分钟数：1000分钟国内主叫，被叫免费范围：全国，数据流量：750M，数据业务：来电显示 \n上网套餐388元】  \n通话分钟数：1400分钟国内主叫，被叫免费范围：全国，数据流量：1000M，数据业务：来电显示 \n【上网套餐588元】  \n通话分钟数：2200分钟国内主叫，被叫免费范围：全国，数据流量：2000M，数据业务：来电显示 \n【上网套餐888元】  \n通话分钟数：3600分钟国内主叫，被叫免费范围：全国，数据流量：3000M，数据业务：来电显示', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:21:02.153000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:29:07.562000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '上网 套餐', 0, '512', 0, '上网套餐', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '【本地套餐58元】  \n通话分钟数：本地主叫国内260分钟，被叫免费范围：国内，数据流量：30M，数据业务：来电显示 \n【本地套餐88元】  \n通话分钟数：本地主叫国内480分钟，被叫免费范围：国内，数据流量：30M，数据业务：来电显示 \n【本地套餐128元】  \n通话分钟数：本地主叫国内750分钟，被叫免费范围：国内，数据流量：30M，数据业务：来电显示', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:21:48.582000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:29:13.704000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '本地 套餐', 0, '513', 0, '本地套餐', 0);

insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '动感地带', null, null, null, null, null, null, 0, to_timestamp('22-10-2014 16:25:03.871000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 18:40:50.183000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '52', 0, '52', 0, '动感地带资费', 1);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '【动感学习套餐15元 】 \n数据流量：10M，数据业务：来电显示、短信260条 \n【上网套餐校园版18元】 \n通话分钟数：30分钟，被叫免费范围：本地，数据流量：30M，数据业务：来电显示、短信100条、WLAN校园时长40小时 \n【上网套餐校园版28元】 \n通话分钟数：50分钟，被叫免费范围：本地，数据流量：60M，数据业务：来电显示、短信150条、WLAN校园时长100小时', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:22:48.793000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:26:35.051000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '动感 地带 校园版', 0, '521', 0, '动感地带校园版', 0);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '【上网套餐18元】  \n通话分钟数：30分钟，被叫免费范围：本地，数据流量：50M，数据业务：来电显示、短信100条 \n【上网套餐28元】  \n通话分钟数：50分钟，被叫免费范围：本地，数据流量：100M，数据业务：来电显示、短信150条 \n【上网套餐38元】  \n通话分钟数：80分钟，被叫免费范围：本地，数据流量：200M，数据业务：来电显示、短信200条', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:23:34.912000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:26:21.270000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '上网 套餐', 0, '522', 0, '上网套餐', 0);


insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '【大众卡10】 \n被叫免费范围：本地 \n【大众卡-百姓套餐10】  \n被叫免费范围：本地，数据业务：来电显示 \n【新长话卡12】 \n被叫免费范围：本地，数据流量：3M，数据业务：赠送来电、彩铃、30条短信、5条彩信 \n【新家园卡10】 \n被叫免费范围：本地,数据流量：3M,数据业务：赠送来电、彩铃、30条短信、5条彩信', null, null, null, null, null, null, 0, to_timestamp('17-09-2014 13:24:54.386000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('13-10-2014 09:26:03.238000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '神州行 资费', 0, '53', 0, '神州行资费', 0);

-- 6
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '最新活动 ', null, null, null, null, null, null, 0, to_timestamp('14-10-2014 14:47:01.445000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 17:06:18.865000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '6', 0, '6', 0, '最新活动', 1);
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'news', null, null, '<a href="http://mp.weixin.qq.com/s?__biz=MzA4NzQ1NjUxMg=='||'&'||'mid=200224867'||'&'||'idx=3'||'&'||'sn=62cfc0bfa013da4d2489fa0ea4cd96ac#rd">【天猫充值99折】</a>精打细算的看过来！', null, null, null, null, 0, to_timestamp('19-09-2014 14:45:44.390000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 13:48:26.390000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '天猫 充值 99折', 0, '61', 0, '【天猫充值99折】精打细算的看过来！', 0);

-- 7
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击此处，进入<a href="http://123.103.63.75:8087/MobileDisplay/AllMobile.aspx">★手机商城★</a>，选购特惠机型。', null, null, null, null, null, null, 0, to_timestamp('22-09-2014 11:45:57.145000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 17:06:46.649000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '手机 商城', 0, '7', 0, '★手机商城★', 0);

-- 8
insert into WECHAT_RESP (id, msgtype, content, mediaid, title, description, musicurl, hqmusicurl, thumbmediaid, status, createtime, createuserid, lastchangedtime, lastchangeduserid, appid, keyword, priority, keyvalue, adddefault, shorttitle, ismenu)
	values (seq_wechat_resp.nextval, 'text', '点击此处，进入<a href="http://wx.wsq.qq.com/251918512">❤微吧❤</a>，畅所欲言吧。', null, null, null, null, null, null, 0, to_timestamp('22-09-2014 11:42:48.315000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, to_timestamp('22-10-2014 17:07:28.943000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, 'woshimorendeappid123', '微吧', 0, '8', 0, '❤微吧❤', 0);


----------------------------------
-- wechat_resp_article
---------------------------------
insert into WECHAT_RESP_ARTICLE (respid, articleid) values (70, 1);
